Pandas Profiling Report

Dataset statistics

Number of variables	36
Number of observations	113216
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	31.1 MiB
Average record size in memory	288.0 B

Variable types

Categorical	8
Numeric	28

Alerts

`actual_delivery_time` is highly overall correlated with `delivery_speed`	High correlation
`churn` is highly overall correlated with `customer_order_frequency` and 1 other fields	High correlation
`customer_order_frequency` is highly overall correlated with `churn` and 1 other fields	High correlation
`customer_review_average` is highly overall correlated with `product_avg_review_score` and 1 other fields	High correlation
`customer_zip_code_prefix` is highly overall correlated with `same_state`	High correlation
`delivery_speed` is highly overall correlated with `actual_delivery_time` and 1 other fields	High correlation
`is_high_value_order` is highly overall correlated with `payment_value` and 1 other fields	High correlation
`multiple_installments` is highly overall correlated with `payment_installments` and 1 other fields	High correlation
`order_item_id` is highly overall correlated with `churn` and 1 other fields	High correlation
`payment_installments` is highly overall correlated with `multiple_installments`	High correlation
`payment_type` is highly overall correlated with `multiple_installments`	High correlation
`payment_value` is highly overall correlated with `is_high_value_order` and 1 other fields	High correlation
`price` is highly overall correlated with `is_high_value_order` and 2 other fields	High correlation
`product_avg_review_score` is highly overall correlated with `customer_review_average`	High correlation
`product_height_cm` is highly overall correlated with `product_weight_g`	High correlation
`product_length_cm` is highly overall correlated with `product_weight_g` and 1 other fields	High correlation
`product_weight_g` is highly overall correlated with `price` and 3 other fields	High correlation
`product_width_cm` is highly overall correlated with `product_length_cm` and 1 other fields	High correlation
`review_score` is highly overall correlated with `customer_review_average`	High correlation
`same_state` is highly overall correlated with `customer_zip_code_prefix` and 1 other fields	High correlation
`order_status` is highly imbalanced (99.9%)	Imbalance
`same_city` is highly imbalanced (70.7%)	Imbalance
`customer_review_response_time` is highly skewed (γ1 = 24.28202129)	Skewed
`product_weight_volume_ratio` is highly skewed (γ1 = 57.36308947)	Skewed
`order_processing_time` has 1481 (1.3%) zeros	Zeros

Reproduction

Analysis started	2024-10-14 19:59:43.493967
Analysis finished	2024-10-14 20:01:35.240286
Duration	1 minute and 51.75 seconds
Software version	ydata-profiling vv4.6.2
Download configuration	config.json

order_status
Categorical

IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.3 MiB

1	113209
0	7

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	113216
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	113209	> 99.9%
0	7	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	113209	> 99.9%
0	7	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
1	113209	> 99.9%
0	7	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	113216	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	113209	> 99.9%
0	7	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	113216	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	113209	> 99.9%
0	7	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	113216	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	113209	> 99.9%
0	7	< 0.1%

order_item_id
Real number (ℝ)

HIGH CORRELATION

Distinct	21
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.1950519

Minimum	1
Maximum	21
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	884.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	2
Maximum	21
Range	20
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.6874736
Coefficient of variation (CV)	0.57526672
Kurtosis	94.231738
Mean	1.1950519
Median Absolute Deviation (MAD)	0
Skewness	7.2298065
Sum	135299
Variance	0.47261995
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
1	99191	87.6%
2	9898	8.7%
3	2287	2.0%
4	943	0.8%
5	442	0.4%
6	250	0.2%
7	60	0.1%
8	35	< 0.1%
9	28	< 0.1%
10	25	< 0.1%
Other values (11)	57	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	99191	87.6%
2	9898	8.7%
3	2287	2.0%
4	943	0.8%
5	442	0.4%
6	250	0.2%
7	60	0.1%
8	35	< 0.1%
9	28	< 0.1%
10	25	< 0.1%

Value	Count	Frequency (%)
21	1	< 0.1%
20	2	< 0.1%
19	2	< 0.1%
18	2	< 0.1%
17	2	< 0.1%
16	2	< 0.1%
15	4	< 0.1%
14	6	< 0.1%
13	7	< 0.1%
12	12	< 0.1%

price
Real number (ℝ)

HIGH CORRELATION

Distinct	5776
Distinct (%)	5.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	119.86974

Minimum	0.85
Maximum	6735
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	884.6 KiB

Quantile statistics

Minimum	0.85
5-th percentile	17
Q1	39.9
median	74.9
Q3	132.985
95-th percentile	349.9
Maximum	6735
Range	6734.15
Interquartile range (IQR)	93.085

Descriptive statistics

Standard deviation	181.12742
Coefficient of variation (CV)	1.5110354
Kurtosis	111.43426
Mean	119.86974
Median Absolute Deviation (MAD)	41.91
Skewness	7.7064743
Sum	13571172
Variance	32807.141
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
59.9	2540	2.2%
69.9	2057	1.8%
49.9	1982	1.8%
89.9	1576	1.4%
99.9	1480	1.3%
29.9	1346	1.2%
39.9	1297	1.1%
19.9	1247	1.1%
79.9	1240	1.1%
29.99	1191	1.1%
Other values (5766)	97260	85.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.85	3	< 0.1%
1.2	20	< 0.1%
2.2	2	< 0.1%
2.29	1	< 0.1%
2.9	1	< 0.1%
2.99	1	< 0.1%
3.06	3	< 0.1%
3.49	3	< 0.1%
3.5	6	< 0.1%
3.54	1	< 0.1%

Value	Count	Frequency (%)
6735	1	< 0.1%
6499	1	< 0.1%
4799	1	< 0.1%
4690	1	< 0.1%
4590	1	< 0.1%
4399.87	1	< 0.1%
4099.99	1	< 0.1%
4059	1	< 0.1%
3999.9	1	< 0.1%
3999	2	< 0.1%

freight_value
Real number (ℝ)

Distinct	6880
Distinct (%)	6.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20.002353

Minimum	0
Maximum	409.68
Zeros	385
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	884.6 KiB

Quantile statistics

Minimum	0
5-th percentile	7.78
Q1	13.08
median	16.32
Q3	21.19
95-th percentile	45.1325
Maximum	409.68
Range	409.68
Interquartile range (IQR)	8.11

Descriptive statistics

Standard deviation	15.710909
Coefficient of variation (CV)	0.78545303
Kurtosis	59.278834
Mean	20.002353
Median Absolute Deviation (MAD)	3.63
Skewness	5.5873821
Sum	2264586.4
Variance	246.83265
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15.1	3690	3.3%
7.78	2235	2.0%
11.85	1910	1.7%
14.1	1886	1.7%
18.23	1580	1.4%
7.39	1530	1.4%
16.11	1169	1.0%
15.23	1025	0.9%
8.72	913	0.8%
16.79	891	0.8%
Other values (6870)	96387	85.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	385	0.3%
0.01	4	< 0.1%
0.02	3	< 0.1%
0.03	11	< 0.1%
0.04	4	< 0.1%
0.05	3	< 0.1%
0.06	13	< 0.1%
0.07	1	< 0.1%
0.08	12	< 0.1%
0.09	6	< 0.1%

Value	Count	Frequency (%)
409.68	1	< 0.1%
375.28	2	< 0.1%
339.59	1	< 0.1%
338.3	1	< 0.1%
322.1	1	< 0.1%
321.88	1	< 0.1%
321.46	1	< 0.1%
317.47	1	< 0.1%
314.4	1	< 0.1%
314.02	1	< 0.1%

product_category_name
Real number (ℝ)

Distinct	73
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	36.758506

Minimum	0
Maximum	72
Zeros	246
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	884.6 KiB

Quantile statistics

Minimum	0
5-th percentile	8
Q1	13
median	32
Q3	55
95-th percentile	72
Maximum	72
Range	72
Interquartile range (IQR)	42

Descriptive statistics

Standard deviation	22.094999
Coefficient of variation (CV)	0.60108533
Kurtosis	-1.3893979
Mean	36.758506
Median Absolute Deviation (MAD)	21
Skewness	0.14922587
Sum	4161651
Variance	488.18897
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13	11684	10.3%
11	9749	8.6%
32	8734	7.7%
54	8554	7.6%
44	7926	7.0%
72	7154	6.3%
66	6030	5.3%
70	4578	4.0%
40	4451	3.9%
8	4259	3.8%
Other values (63)	40097	35.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	246	0.2%
1	503	0.4%
2	281	0.2%
3	205	0.2%
4	24	< 0.1%
5	45	< 0.1%
6	145	0.1%
7	375	0.3%
8	4259	3.8%
9	3095	2.7%

Value	Count	Frequency (%)
72	7154	6.3%
71	259	0.2%
70	4578	4.0%
69	85	0.1%
68	198	0.2%
67	2	< 0.1%
66	6030	5.3%
65	14	< 0.1%
64	75	0.1%
63	1998	1.8%

product_name_lenght
Real number (ℝ)

Distinct	65
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	48.804224

Minimum	5
Maximum	76
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	884.6 KiB

Quantile statistics

Minimum	5
5-th percentile	29
Q1	42
median	52
Q3	57
95-th percentile	60
Maximum	76
Range	71
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	10.015776
Coefficient of variation (CV)	0.20522355
Kurtosis	0.15746467
Mean	48.804224
Median Absolute Deviation (MAD)	6
Skewness	-0.91022452
Sum	5525419
Variance	100.31577
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
59	8457	7.5%
60	7857	6.9%
56	6713	5.9%
58	6651	5.9%
57	6169	5.4%
55	5715	5.0%
54	5367	4.7%
53	4229	3.7%
52	4208	3.7%
49	3591	3.2%
Other values (55)	54259	47.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5	9	< 0.1%
6	3	< 0.1%
7	1	< 0.1%
8	4	< 0.1%
9	13	< 0.1%
10	8	< 0.1%
11	9	< 0.1%
12	35	< 0.1%
13	25	< 0.1%
14	45	< 0.1%

Value	Count	Frequency (%)
76	1	< 0.1%
72	9	< 0.1%
68	1	< 0.1%
67	3	< 0.1%
66	1	< 0.1%
64	165	0.1%
63	1289	1.1%
62	152	0.1%
61	231	0.2%
60	7857	6.9%

product_description_lenght
Real number (ℝ)

Distinct	2942
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	784.72571

Minimum	4
Maximum	3992
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	884.6 KiB

Quantile statistics

Minimum	4
5-th percentile	160
Q1	346
median	600
Q3	982
95-th percentile	2115
Maximum	3992
Range	3988
Interquartile range (IQR)	636

Descriptive statistics

Standard deviation	650.30034
Coefficient of variation (CV)	0.82869763
Kurtosis	4.9213171
Mean	784.72571
Median Absolute Deviation (MAD)	296
Skewness	2.0074977
Sum	88843506
Variance	422890.53
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
341	701	0.6%
1893	650	0.6%
348	640	0.6%
903	579	0.5%
492	576	0.5%
245	564	0.5%
366	530	0.5%
236	502	0.4%
340	479	0.4%
919	430	0.4%
Other values (2932)	107565	95.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4	6	< 0.1%
8	2	< 0.1%
15	1	< 0.1%
20	7	< 0.1%
23	1	< 0.1%
26	2	< 0.1%
27	4	< 0.1%
28	2	< 0.1%
30	6	< 0.1%
31	2	< 0.1%

Value	Count	Frequency (%)
3992	1	< 0.1%
3988	1	< 0.1%
3985	3	< 0.1%
3976	5	< 0.1%
3963	1	< 0.1%
3956	1	< 0.1%
3954	2	< 0.1%
3950	2	< 0.1%
3949	1	< 0.1%
3948	1	< 0.1%

product_photos_qty
Real number (ℝ)

Distinct	19
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.2069672

Minimum	1
Maximum	20
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	884.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	3
95-th percentile	6
Maximum	20
Range	19
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.7183176
Coefficient of variation (CV)	0.77858773
Kurtosis	4.7658561
Mean	2.2069672
Median Absolute Deviation (MAD)	0
Skewness	1.9035146
Sum	249864
Variance	2.9526153
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=19)

Value	Count	Frequency (%)
1	57179	50.5%
2	22407	19.8%
3	12617	11.1%
4	8594	7.6%
5	5462	4.8%
6	3836	3.4%
7	1522	1.3%
8	757	0.7%
10	346	0.3%
9	300	0.3%
Other values (9)	196	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	57179	50.5%
2	22407	19.8%
3	12617	11.1%
4	8594	7.6%
5	5462	4.8%
6	3836	3.4%
7	1522	1.3%
8	757	0.7%
9	300	0.3%
10	346	0.3%

Value	Count	Frequency (%)
20	1	< 0.1%
19	1	< 0.1%
18	4	< 0.1%
17	11	< 0.1%
15	11	< 0.1%
14	6	< 0.1%
13	30	< 0.1%
12	59	0.1%
11	73	0.1%
10	346	0.3%

product_weight_g
Real number (ℝ)

HIGH CORRELATION

Distinct	2166
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2106.3464

Minimum	0
Maximum	40425
Zeros	8
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	884.6 KiB

Quantile statistics

Minimum	0
5-th percentile	125
Q1	300
median	700
Q3	1800
95-th percentile	9800
Maximum	40425
Range	40425
Interquartile range (IQR)	1500

Descriptive statistics

Standard deviation	3765.0347
Coefficient of variation (CV)	1.7874718
Kurtosis	16.121507
Mean	2106.3464
Median Absolute Deviation (MAD)	500
Skewness	3.5870748
Sum	2.3847211 × 10⁸
Variance	14175486
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
200	6706	5.9%
150	5257	4.6%
250	4596	4.1%
300	4218	3.7%
100	3493	3.1%
400	3411	3.0%
350	3165	2.8%
600	2724	2.4%
500	2699	2.4%
700	2048	1.8%
Other values (2156)	74899	66.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	8	< 0.1%
2	5	< 0.1%
25	3	< 0.1%
50	911	0.8%
53	2	< 0.1%
54	2	< 0.1%
55	1	< 0.1%
58	1	< 0.1%
60	6	< 0.1%
61	5	< 0.1%

Value	Count	Frequency (%)
40425	3	< 0.1%
30000	284	0.3%
29800	1	< 0.1%
29700	3	< 0.1%
29600	5	< 0.1%
29500	2	< 0.1%
29250	1	< 0.1%
29150	1	< 0.1%
29100	1	< 0.1%
29050	5	< 0.1%

product_length_cm
Real number (ℝ)

HIGH CORRELATION

Distinct	99
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	30.276922

Minimum	7
Maximum	105
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	884.6 KiB

Quantile statistics

Minimum	7
5-th percentile	16
Q1	18
median	25
Q3	38
95-th percentile	62
Maximum	105
Range	98
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	16.14408
Coefficient of variation (CV)	0.53321405
Kurtosis	3.624952
Mean	30.276922
Median Absolute Deviation (MAD)	8
Skewness	1.7329387
Sum	3427832
Variance	260.63133
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16	17370	15.3%
20	10364	9.2%
30	7672	6.8%
17	5997	5.3%
18	5686	5.0%
19	4754	4.2%
25	4689	4.1%
40	4137	3.7%
22	3868	3.4%
50	3028	2.7%
Other values (89)	45651	40.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
7	32	< 0.1%
8	2	< 0.1%
9	4	< 0.1%
10	8	< 0.1%
11	96	0.1%
12	41	< 0.1%
13	57	0.1%
14	130	0.1%
15	209	0.2%
16	17370	15.3%

Value	Count	Frequency (%)
105	308	0.3%
104	30	< 0.1%
103	44	< 0.1%
102	60	0.1%
101	107	0.1%
100	383	0.3%
99	34	< 0.1%
98	49	< 0.1%
97	11	< 0.1%
96	8	< 0.1%

product_height_cm
Real number (ℝ)

HIGH CORRELATION

Distinct	102
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16.598652

Minimum	2
Maximum	105
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	884.6 KiB

Quantile statistics

Minimum	2
5-th percentile	3
Q1	8
median	13
Q3	20
95-th percentile	45
Maximum	105
Range	103
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	13.43674
Coefficient of variation (CV)	0.80950791
Kurtosis	7.2822014
Mean	16.598652
Median Absolute Deviation (MAD)	6
Skewness	2.2429305
Sum	1879233
Variance	180.54599
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10	10018	8.8%
15	6648	5.9%
20	6643	5.9%
11	6170	5.4%
12	6090	5.4%
2	5001	4.4%
4	4692	4.1%
8	4683	4.1%
16	4568	4.0%
5	4536	4.0%
Other values (92)	54167	47.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	5001	4.4%
3	2727	2.4%
4	4692	4.1%
5	4536	4.0%
6	3460	3.1%
7	4146	3.7%
8	4683	4.1%
9	3323	2.9%
10	10018	8.8%
11	6170	5.4%

Value	Count	Frequency (%)
105	132	0.1%
104	12	< 0.1%
103	49	< 0.1%
102	10	< 0.1%
100	39	< 0.1%
99	5	< 0.1%
98	3	< 0.1%
97	2	< 0.1%
96	5	< 0.1%
95	22	< 0.1%

product_width_cm
Real number (ℝ)

HIGH CORRELATION

Distinct	94
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23.099412

Minimum	6
Maximum	118
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	884.6 KiB

Quantile statistics

Minimum	6
5-th percentile	11
Q1	15
median	20
Q3	30
95-th percentile	45
Maximum	118
Range	112
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	11.734956
Coefficient of variation (CV)	0.50801969
Kurtosis	4.5419969
Mean	23.099412
Median Absolute Deviation (MAD)	6
Skewness	1.7038327
Sum	2615223
Variance	137.70919
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20	12199	10.8%
11	10442	9.2%
15	8770	7.7%
16	8503	7.5%
30	7729	6.8%
12	5484	4.8%
13	5314	4.7%
14	4659	4.1%
18	4047	3.6%
40	3953	3.5%
Other values (84)	42116	37.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6	2	< 0.1%
7	5	< 0.1%
8	29	< 0.1%
9	49	< 0.1%
10	81	0.1%
11	10442	9.2%
12	5484	4.8%
13	5314	4.7%
14	4659	4.1%
15	8770	7.7%

Value	Count	Frequency (%)
118	7	< 0.1%
105	13	< 0.1%
104	1	< 0.1%
102	2	< 0.1%
101	2	< 0.1%
100	42	< 0.1%
98	1	< 0.1%
97	1	< 0.1%
95	2	< 0.1%
93	17	< 0.1%

customer_zip_code_prefix
Real number (ℝ)

HIGH CORRELATION

Distinct	14825
Distinct (%)	13.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	35084.549

Minimum	1003
Maximum	99980
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	884.6 KiB

Quantile statistics

Minimum	1003
5-th percentile	3282
Q1	11310
median	24315
Q3	58844.25
95-th percentile	90640
Maximum	99980
Range	98977
Interquartile range (IQR)	47534.25

Descriptive statistics

Standard deviation	29867.207
Coefficient of variation (CV)	0.85129233
Kurtosis	-0.78634662
Mean	35084.549
Median Absolute Deviation (MAD)	16294
Skewness	0.78379092
Sum	3.9721323 × 10⁹
Variance	8.9205008 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
24220	150	0.1%
22793	146	0.1%
22790	144	0.1%
24230	138	0.1%
35162	123	0.1%
22775	119	0.1%
29101	111	0.1%
13087	107	0.1%
36570	103	0.1%
11740	100	0.1%
Other values (14815)	111975	98.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1003	1	< 0.1%
1004	2	< 0.1%
1005	6	< 0.1%
1006	2	< 0.1%
1007	4	< 0.1%
1008	3	< 0.1%
1009	8	< 0.1%
1011	6	< 0.1%
1012	2	< 0.1%
1013	3	< 0.1%

Value	Count	Frequency (%)
99980	3	< 0.1%
99970	1	< 0.1%
99965	2	< 0.1%
99960	1	< 0.1%
99955	3	< 0.1%
99950	9	< 0.1%
99940	2	< 0.1%
99930	5	< 0.1%
99925	1	< 0.1%
99920	1	< 0.1%

review_score
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.3 MiB

5	65153
4	21816
1	12870
3	9536
2	3841

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	113216
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	4
2nd row	4
3rd row	4
4th row	4
5th row	5

Common Values

Value	Count	Frequency (%)
5	65153	57.5%
4	21816	19.3%
1	12870	11.4%
3	9536	8.4%
2	3841	3.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
5	65153	57.5%
4	21816	19.3%
1	12870	11.4%
3	9536	8.4%
2	3841	3.4%

Most occurring characters

Value	Count	Frequency (%)
5	65153	57.5%
4	21816	19.3%
1	12870	11.4%
3	9536	8.4%
2	3841	3.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	113216	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
5	65153	57.5%
4	21816	19.3%
1	12870	11.4%
3	9536	8.4%
2	3841	3.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	113216	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
5	65153	57.5%
4	21816	19.3%
1	12870	11.4%
3	9536	8.4%
2	3841	3.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	113216	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
5	65153	57.5%
4	21816	19.3%
1	12870	11.4%
3	9536	8.4%
2	3841	3.4%

seller_zip_code_prefix
Real number (ℝ)

Distinct	2133
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24522.45

Minimum	1001
Maximum	99730
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	884.6 KiB

Quantile statistics

Minimum	1001
5-th percentile	2972
Q1	6429
median	13660
Q3	28495
95-th percentile	88340
Maximum	99730
Range	98729
Interquartile range (IQR)	22066

Descriptive statistics

Standard deviation	27646.98
Coefficient of variation (CV)	1.1274151
Kurtosis	0.90357605
Mean	24522.45
Median Absolute Deviation (MAD)	8130
Skewness	1.5474768
Sum	2.7763337 × 10⁹
Variance	7.6435548 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14940	8097	7.2%
5849	2091	1.8%
15025	2084	1.8%
9015	1833	1.6%
13405	1661	1.5%
8577	1535	1.4%
4782	1509	1.3%
3204	1456	1.3%
4160	1242	1.1%
13232	1225	1.1%
Other values (2123)	90483	79.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1001	22	< 0.1%
1021	41	< 0.1%
1022	5	< 0.1%
1023	5	< 0.1%
1026	294	0.3%
1031	122	0.1%
1035	18	< 0.1%
1039	1	< 0.1%
1040	20	< 0.1%
1041	2	< 0.1%

Value	Count	Frequency (%)
99730	12	< 0.1%
99700	2	< 0.1%
99670	1	< 0.1%
99500	61	0.1%
99300	2	< 0.1%
98975	19	< 0.1%
98920	1	< 0.1%
98910	13	< 0.1%
98803	63	0.1%
98780	4	< 0.1%

payment_sequential
Real number (ℝ)

Distinct	26
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.0908087

Minimum	1
Maximum	26
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	884.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	1
Maximum	26
Range	25
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.68661048
Coefficient of variation (CV)	0.62945086
Kurtosis	310.24927
Mean	1.0908087
Median Absolute Deviation (MAD)	0
Skewness	15.109333
Sum	123497
Variance	0.47143396
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=26)

Value	Count	Frequency (%)
1	108376	95.7%
2	3240	2.9%
3	627	0.6%
4	303	0.3%
5	180	0.2%
6	124	0.1%
7	85	0.1%
8	55	< 0.1%
9	44	< 0.1%
10	38	< 0.1%
Other values (16)	144	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	108376	95.7%
2	3240	2.9%
3	627	0.6%
4	303	0.3%
5	180	0.2%
6	124	0.1%
7	85	0.1%
8	55	< 0.1%
9	44	< 0.1%
10	38	< 0.1%

Value	Count	Frequency (%)
26	1	< 0.1%
25	1	< 0.1%
24	1	< 0.1%
23	1	< 0.1%
22	2	< 0.1%
21	5	< 0.1%
20	5	< 0.1%
19	8	< 0.1%
18	8	< 0.1%
17	8	< 0.1%

payment_type
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.3 MiB

1	83545
0	22022
3	6023
2	1626

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	113216
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	3
3rd row	3
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	83545	73.8%
0	22022	19.5%
3	6023	5.3%
2	1626	1.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	83545	73.8%
0	22022	19.5%
3	6023	5.3%
2	1626	1.4%

Most occurring characters

Value	Count	Frequency (%)
1	83545	73.8%
0	22022	19.5%
3	6023	5.3%
2	1626	1.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	113216	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	83545	73.8%
0	22022	19.5%
3	6023	5.3%
2	1626	1.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	113216	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	83545	73.8%
0	22022	19.5%
3	6023	5.3%
2	1626	1.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	113216	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	83545	73.8%
0	22022	19.5%
3	6023	5.3%
2	1626	1.4%

payment_installments
Real number (ℝ)

HIGH CORRELATION

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.9435151

Minimum	0
Maximum	24
Zeros	3
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	884.6 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	2
Q3	4
95-th percentile	10
Maximum	24
Range	24
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.7791372
Coefficient of variation (CV)	0.94415593
Kurtosis	2.5465187
Mean	2.9435151
Median Absolute Deviation (MAD)	1
Skewness	1.6231193
Sum	333253
Variance	7.7236036
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
1	56418	49.8%
2	13155	11.6%
3	11317	10.0%
4	7694	6.8%
10	6634	5.9%
5	5812	5.1%
8	4879	4.3%
6	4453	3.9%
7	1739	1.5%
9	695	0.6%
Other values (14)	420	0.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3	< 0.1%
1	56418	49.8%
2	13155	11.6%
3	11317	10.0%
4	7694	6.8%
5	5812	5.1%
6	4453	3.9%
7	1739	1.5%
8	4879	4.3%
9	695	0.6%

Value	Count	Frequency (%)
24	34	< 0.1%
23	1	< 0.1%
22	1	< 0.1%
21	6	< 0.1%
20	19	< 0.1%
18	38	< 0.1%
17	7	< 0.1%
16	7	< 0.1%
15	88	0.1%
14	15	< 0.1%

payment_value
Real number (ℝ)

HIGH CORRELATION

Distinct	28277
Distinct (%)	25.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	171.57792

Minimum	0
Maximum	13664.08
Zeros	4
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	884.6 KiB

Quantile statistics

Minimum	0
5-th percentile	27.2675
Q1	60.85
median	107.97
Q3	189.16
95-th percentile	511.065
Maximum	13664.08
Range	13664.08
Interquartile range (IQR)	128.31

Descriptive statistics

Standard deviation	264.21868
Coefficient of variation (CV)	1.539934
Kurtosis	547.20669
Mean	171.57792
Median Absolute Deviation (MAD)	56.57
Skewness	14.648382
Sum	19425366
Variance	69811.509
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
50	336	0.3%
100	282	0.2%
20	281	0.2%
77.57	245	0.2%
35	162	0.1%
73.34	157	0.1%
30	130	0.1%
116.94	130	0.1%
155.14	119	0.1%
107.78	116	0.1%
Other values (28267)	111258	98.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4	< 0.1%
0.01	6	< 0.1%
0.03	2	< 0.1%
0.05	2	< 0.1%
0.08	2	< 0.1%
0.09	1	< 0.1%
0.1	3	< 0.1%
0.11	2	< 0.1%
0.13	1	< 0.1%
0.14	4	< 0.1%

Value	Count	Frequency (%)
13664.08	8	< 0.1%
7274.88	4	< 0.1%
6929.31	1	< 0.1%
6726.66	1	< 0.1%
6081.54	6	< 0.1%
4950.34	1	< 0.1%
4764.34	1	< 0.1%
4681.78	1	< 0.1%
4513.32	1	< 0.1%
4445.5	2	< 0.1%

churn
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.3 MiB

1	77746
0	35470

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	113216
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	77746	68.7%
0	35470	31.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	77746	68.7%
0	35470	31.3%

Most occurring characters

Value	Count	Frequency (%)
1	77746	68.7%
0	35470	31.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	113216	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	77746	68.7%
0	35470	31.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	113216	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	77746	68.7%
0	35470	31.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	113216	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	77746	68.7%
0	35470	31.3%

order_processing_time
Real number (ℝ)

ZEROS

Distinct	32110
Distinct (%)	28.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.434418

Minimum	0
Maximum	741.44361
Zeros	1481
Zeros (%)	1.3%
Negative	0
Negative (%)	0.0%
Memory size	884.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0.14388889
Q1	0.21611111
median	0.34722222
Q3	14.941597
95-th percentile	48.447431
Maximum	741.44361
Range	741.44361
Interquartile range (IQR)	14.725486

Descriptive statistics

Standard deviation	20.948871
Coefficient of variation (CV)	2.0076702
Kurtosis	87.016468
Mean	10.434418
Median Absolute Deviation (MAD)	0.18611111
Skewness	5.1473332
Sum	1181343.1
Variance	438.8552
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1481	1.3%
0.2027777778	137	0.1%
0.1936111111	135	0.1%
0.2111111111	135	0.1%
0.2080555556	129	0.1%
0.2005555556	128	0.1%
0.1938888889	127	0.1%
0.1891666667	125	0.1%
0.2280555556	123	0.1%
0.2136111111	121	0.1%
Other values (32100)	110575	97.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1481	1.3%
0.08861111111	1	< 0.1%
0.08972222222	1	< 0.1%
0.09	1	< 0.1%
0.09083333333	1	< 0.1%
0.09138888889	1	< 0.1%
0.09166666667	4	< 0.1%
0.09194444444	2	< 0.1%
0.0925	2	< 0.1%
0.09277777778	1	< 0.1%

Value	Count	Frequency (%)
741.4436111	1	< 0.1%
738.4488889	4	< 0.1%
554.785	1	< 0.1%
404.2288889	1	< 0.1%
319.5327778	1	< 0.1%
313.7986111	1	< 0.1%
300.4275	1	< 0.1%
299.5177778	1	< 0.1%
298.9447222	1	< 0.1%
291.4105556	1	< 0.1%

shipping_delay
Real number (ℝ)

Distinct	90079
Distinct (%)	79.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-273.44804

Minimum	-3504.3869
Maximum	4535.4019
Zeros	0
Zeros (%)	0.0%
Negative	104501
Negative (%)	92.3%
Memory size	884.6 KiB

Quantile statistics

Minimum	-3504.3869
5-th percentile	-627.88667
Q1	-391.70681
median	-289.63236
Q3	-157.13896
95-th percentile	81.57125
Maximum	4535.4019
Range	8039.7889
Interquartile range (IQR)	234.56785

Descriptive statistics

Standard deviation	242.21599
Coefficient of variation (CV)	-0.88578433
Kurtosis	27.583561
Mean	-273.44804
Median Absolute Deviation (MAD)	118.86931
Skewness	1.8481739
Sum	-30958694
Variance	58668.587
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-371.2283333	63	0.1%
-97.40277778	38	< 0.1%
-127.9205556	26	< 0.1%
-249.0116667	24	< 0.1%
-195.8447222	24	< 0.1%
-267.1291667	24	< 0.1%
-202.4541667	24	< 0.1%
-80.6875	24	< 0.1%
-273.2683333	22	< 0.1%
-295.4472222	22	< 0.1%
Other values (90069)	112925	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-3504.386944	2	< 0.1%
-3345.5375	1	< 0.1%
-3223.404722	1	< 0.1%
-2962.401667	2	< 0.1%
-2602.181389	1	< 0.1%
-1993.693611	1	< 0.1%
-1990.123889	1	< 0.1%
-1855.786111	1	< 0.1%
-1852.639167	1	< 0.1%
-1851.630556	2	< 0.1%

Value	Count	Frequency (%)
4535.401944	1	< 0.1%
4220.858611	1	< 0.1%
4025.001944	1	< 0.1%
3998.001111	1	< 0.1%
3975.213889	1	< 0.1%
3905.240278	1	< 0.1%
3882.608056	4	< 0.1%
3878.639167	1	< 0.1%
3830.638333	1	< 0.1%
3734.554722	1	< 0.1%

actual_delivery_time
Real number (ℝ)

HIGH CORRELATION

Distinct	91924
Distinct (%)	81.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	298.58225

Minimum	12.801944
Maximum	5000.4422
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	884.6 KiB

Quantile statistics

Minimum	12.801944
5-th percentile	72.045556
Q1	161.73299
median	244.50889
Q3	372.05299
95-th percentile	693.45083
Maximum	5000.4422
Range	4987.6403
Interquartile range (IQR)	210.32

Descriptive statistics

Standard deviation	224.52717
Coefficient of variation (CV)	0.75197764
Kurtosis	39.288939
Mean	298.58225
Median Absolute Deviation (MAD)	98.685139
Skewness	3.7958224
Sum	33804288
Variance	50412.451
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
136.3297222	63	0.1%
607.6513889	38	< 0.1%
363.9933333	26	< 0.1%
485.9422222	24	< 0.1%
482.8297222	24	< 0.1%
277.8886111	24	< 0.1%
339.5811111	24	< 0.1%
121.0775	24	< 0.1%
121.6236111	22	< 0.1%
316.5516667	22	< 0.1%
Other values (91914)	112925	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12.80194444	1	< 0.1%
18.75277778	1	< 0.1%
20.5275	1	< 0.1%
20.72222222	6	< 0.1%
21.37805556	1	< 0.1%
21.41972222	1	< 0.1%
22.46361111	2	< 0.1%
22.51638889	1	< 0.1%
23.625	1	< 0.1%
23.655	1	< 0.1%

Value	Count	Frequency (%)
5000.442222	1	< 0.1%
4695.216389	1	< 0.1%
4676.404167	1	< 0.1%
4671.206667	1	< 0.1%
4657.19	1	< 0.1%
4595.125	1	< 0.1%
4556.715833	1	< 0.1%
4515.230833	1	< 0.1%
4505.852222	1	< 0.1%
4492.882778	2	< 0.1%

delivery_speed
Real number (ℝ)

HIGH CORRELATION

Distinct	90380
Distinct (%)	79.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	220.02926

Minimum	-386.30806
Maximum	4924.5833
Zeros	10
Zeros (%)	< 0.1%
Negative	58
Negative (%)	0.1%
Memory size	884.6 KiB

Quantile statistics

Minimum	-386.30806
5-th percentile	26.791181
Q1	97.502222
median	169.40875
Q3	285.83715
95-th percentile	571.78639
Maximum	4924.5833
Range	5310.8914
Interquartile range (IQR)	188.33493

Descriptive statistics

Standard deviation	205.29044
Coefficient of variation (CV)	0.93301424
Kurtosis	54.7427
Mean	220.02926
Median Absolute Deviation (MAD)	89.532778
Skewness	4.5726296
Sum	24910833
Variance	42144.164
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
72	65	0.1%
96.80111111	63	0.1%
382.7988889	38	< 0.1%
73	33	< 0.1%
311.4783333	26	< 0.1%
144.2383333	26	< 0.1%
432.8958333	24	< 0.1%
143.6027778	24	< 0.1%
68.15555556	24	< 0.1%
414.8755556	24	< 0.1%
Other values (90370)	112869	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-386.3080556	2	< 0.1%
-189.095	2	< 0.1%
-171.9702778	2	< 0.1%
-144.2388889	12	< 0.1%
-137.6636111	1	< 0.1%
-136.5697222	1	< 0.1%
-120.9483333	2	< 0.1%
-118.6394444	2	< 0.1%
-69.41722222	3	< 0.1%
-47.63916667	2	< 0.1%

Value	Count	Frequency (%)
4924.583333	1	< 0.1%
4661.112222	1	< 0.1%
4565.654167	1	< 0.1%
4514.211667	1	< 0.1%
4493.150556	1	< 0.1%
4473.603889	1	< 0.1%
4376.104167	2	< 0.1%
4370.4	1	< 0.1%
4367.754167	1	< 0.1%
4353.168611	1	< 0.1%

customer_order_frequency
Real number (ℝ)

HIGH CORRELATION

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.6626979

Minimum	1
Maximum	63
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	884.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	4
Maximum	63
Range	62
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	2.3797477
Coefficient of variation (CV)	1.4312569
Kurtosis	281.30382
Mean	1.6626979
Median Absolute Deviation (MAD)	0
Skewness	13.472147
Sum	188244
Variance	5.6631993
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
1	82126	72.5%
2	18834	16.6%
3	4455	3.9%
4	3160	2.8%
6	1608	1.4%
5	1155	1.0%
7	322	0.3%
8	312	0.3%
12	240	0.2%
10	140	0.1%
Other values (14)	864	0.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	82126	72.5%
2	18834	16.6%
3	4455	3.9%
4	3160	2.8%
5	1155	1.0%
6	1608	1.4%
7	322	0.3%
8	312	0.3%
9	99	0.1%
10	140	0.1%

Value	Count	Frequency (%)
63	63	0.1%
38	38	< 0.1%
26	26	< 0.1%
24	120	0.1%
22	44	< 0.1%
21	63	0.1%
20	40	< 0.1%
19	19	< 0.1%
16	32	< 0.1%
15	90	0.1%

customer_review_average
Real number (ℝ)

HIGH CORRELATION

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.0823647

Minimum	1
Maximum	5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	884.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	5
Q3	5
95-th percentile	5
Maximum	5
Range	4
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.3436345
Coefficient of variation (CV)	0.32913142
Kurtosis	0.48271726
Mean	4.0823647
Median Absolute Deviation (MAD)	0
Skewness	-1.3512568
Sum	462189
Variance	1.8053537
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
5	64990	57.4%
4	21731	19.2%
1	12761	11.3%
3	9572	8.5%
2	3818	3.4%
4.5	156	0.1%
2.5	88	0.1%
3.5	58	0.1%
1.5	36	< 0.1%
4.333333333	3	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	12761	11.3%
1.5	36	< 0.1%
2	3818	3.4%
2.5	88	0.1%
3	9572	8.5%
3.333333333	3	< 0.1%
3.5	58	0.1%
4	21731	19.2%
4.333333333	3	< 0.1%
4.5	156	0.1%

Value	Count	Frequency (%)
5	64990	57.4%
4.5	156	0.1%
4.333333333	3	< 0.1%
4	21731	19.2%
3.5	58	0.1%
3.333333333	3	< 0.1%
3	9572	8.5%
2.5	88	0.1%
2	3818	3.4%
1.5	36	< 0.1%

customer_review_response_time
Real number (ℝ)

SKEWED

Distinct	78941
Distinct (%)	69.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	75.711531

Minimum	2.1413889
Maximum	12448.781
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	884.6 KiB

Quantile statistics

Minimum	2.1413889
5-th percentile	15.765625
Q1	24.326111
median	40.529028
Q3	74.992014
95-th percentile	167.59097
Maximum	12448.781
Range	12446.64
Interquartile range (IQR)	50.665903

Descriptive statistics

Standard deviation	235.11404
Coefficient of variation (CV)	3.1053927
Kurtosis	837.91044
Mean	75.711531
Median Absolute Deviation (MAD)	20.891389
Skewness	24.282021
Sum	8571756.7
Variance	55278.611
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
70.29861111	63	0.1%
21.14555556	38	< 0.1%
138.8305556	26	< 0.1%
109.3419444	25	< 0.1%
32.57027778	24	< 0.1%
159.1361111	24	< 0.1%
67.07222222	24	< 0.1%
20.56444444	22	< 0.1%
19.43194444	22	< 0.1%
68.07666667	21	< 0.1%
Other values (78931)	112927	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.141388889	1	< 0.1%
2.436944444	1	< 0.1%
2.482222222	1	< 0.1%
2.503333333	1	< 0.1%
2.610555556	1	< 0.1%
2.62	1	< 0.1%
2.633611111	1	< 0.1%
2.654444444	1	< 0.1%
2.679722222	2	< 0.1%
2.7175	1	< 0.1%

Value	Count	Frequency (%)
12448.78111	1	< 0.1%
12303.79361	1	< 0.1%
12193.6025	3	< 0.1%
11320.33139	1	< 0.1%
10724.85944	1	< 0.1%
10415.51583	1	< 0.1%
9900.504167	1	< 0.1%
9874.653611	1	< 0.1%
9202.336389	1	< 0.1%
8824.365556	1	< 0.1%

product_popularity
Real number (ℝ)

Distinct	141
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	37.399784

Minimum	1
Maximum	526
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	884.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	8
Q3	27
95-th percentile	175
Maximum	526
Range	525
Interquartile range (IQR)	24

Descriptive statistics

Standard deviation	83.568429
Coefficient of variation (CV)	2.2344629
Kurtosis	16.662447
Mean	37.399784
Median Absolute Deviation (MAD)	7
Skewness	3.9270731
Sum	4234254
Variance	6983.6823
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	16572	14.6%
2	11494	10.2%
3	7920	7.0%
4	6152	5.4%
5	4935	4.4%
6	4644	4.1%
7	3598	3.2%
8	3224	2.8%
9	2682	2.4%
10	2550	2.3%
Other values (131)	49445	43.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	16572	14.6%
2	11494	10.2%
3	7920	7.0%
4	6152	5.4%
5	4935	4.4%
6	4644	4.1%
7	3598	3.2%
8	3224	2.8%
9	2682	2.4%
10	2550	2.3%

Value	Count	Frequency (%)
526	526	0.5%
507	1014	0.9%
402	402	0.4%
395	395	0.3%
389	389	0.3%
344	344	0.3%
323	323	0.3%
286	286	0.3%
275	275	0.2%
269	269	0.2%

seller_popularity
Real number (ℝ)

Distinct	261
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	445.82101

Minimum	1
Maximum	2093
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	884.6 KiB

Quantile statistics

Minimum	1
5-th percentile	10
Q1	59
median	178
Q3	557
95-th percentile	2003
Maximum	2093
Range	2092
Interquartile range (IQR)	498

Descriptive statistics

Standard deviation	587.88955
Coefficient of variation (CV)	1.3186672
Kurtosis	1.4167256
Mean	445.82101
Median Absolute Deviation (MAD)	151
Skewness	1.6214245
Sum	50474072
Variance	345614.12
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2093	2093	1.8%
2076	2076	1.8%
2003	2003	1.8%
1828	1828	1.6%
1650	1650	1.5%
1492	1492	1.3%
1456	1456	1.3%
1445	1445	1.3%
1218	1218	1.1%
1217	1217	1.1%
Other values (251)	96738	85.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	464	0.4%
2	542	0.5%
3	570	0.5%
4	548	0.5%
5	715	0.6%
6	642	0.6%
7	616	0.5%
8	696	0.6%
9	585	0.5%
10	650	0.6%

Value	Count	Frequency (%)
2093	2093	1.8%
2076	2076	1.8%
2003	2003	1.8%
1828	1828	1.6%
1650	1650	1.5%
1492	1492	1.3%
1456	1456	1.3%
1445	1445	1.3%
1218	1218	1.1%
1217	1217	1.1%

product_weight_volume_ratio
Real number (ℝ)

SKEWED

Distinct	13232
Distinct (%)	11.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1917133

Minimum	0
Maximum	85.227273
Zeros	8
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	884.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0.026859157
Q1	0.06719697
median	0.11222615
Q3	0.19097222
95-th percentile	0.52910053
Maximum	85.227273
Range	85.227273
Interquartile range (IQR)	0.12377525

Descriptive statistics

Standard deviation	0.79408188
Coefficient of variation (CV)	4.142028
Kurtosis	4202.1591
Mean	0.1917133
Median Absolute Deviation (MAD)	0.056522054
Skewness	57.363089
Sum	21705.014
Variance	0.63056603
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.08333333333	740	0.7%
0.5681818182	605	0.5%
0.390625	583	0.5%
0.1	581	0.5%
0.3676470588	567	0.5%
0.7102272727	553	0.5%
0.1733333333	543	0.5%
0.07575757576	541	0.5%
0.07828282828	507	0.4%
0.06915	507	0.4%
Other values (13222)	107489	94.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	8	< 0.1%
0.0003178639542	5	< 0.1%
0.0008405056482	1	< 0.1%
0.0008818342152	3	< 0.1%
0.001485714286	1	< 0.1%
0.0015	1	< 0.1%
0.00202560363	1	< 0.1%
0.002083333333	40	< 0.1%
0.002222222222	14	< 0.1%
0.002506265664	2	< 0.1%

Value	Count	Frequency (%)
85.22727273	1	< 0.1%
65.90909091	2	< 0.1%
62.78409091	3	< 0.1%
48.15340909	2	< 0.1%
45.88068182	4	< 0.1%
45.45454545	2	< 0.1%
40.05681818	2	< 0.1%
35.79545455	5	< 0.1%
32.38636364	1	< 0.1%
30.82386364	2	< 0.1%

same_state
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.3 MiB

0	72324
1	40892

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	113216
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
0	72324	63.9%
1	40892	36.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	72324	63.9%
1	40892	36.1%

Most occurring characters

Value	Count	Frequency (%)
0	72324	63.9%
1	40892	36.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	113216	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	72324	63.9%
1	40892	36.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	113216	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	72324	63.9%
1	40892	36.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	113216	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	72324	63.9%
1	40892	36.1%

is_high_value_order
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.3 MiB

0	84914
1	28302

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	113216
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	84914	75.0%
1	28302	25.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	84914	75.0%
1	28302	25.0%

Most occurring characters

Value	Count	Frequency (%)
0	84914	75.0%
1	28302	25.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	113216	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	84914	75.0%
1	28302	25.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	113216	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	84914	75.0%
1	28302	25.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	113216	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	84914	75.0%
1	28302	25.0%

multiple_installments
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.3 MiB

1	56795
0	56421

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	113216
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	1
5th row	0

Common Values

Value	Count	Frequency (%)
1	56795	50.2%
0	56421	49.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	56795	50.2%
0	56421	49.8%

Most occurring characters

Value	Count	Frequency (%)
1	56795	50.2%
0	56421	49.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	113216	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	56795	50.2%
0	56421	49.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	113216	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	56795	50.2%
0	56421	49.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	113216	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	56795	50.2%
0	56421	49.8%

product_avg_review_score
Real number (ℝ)

HIGH CORRELATION

Distinct	689
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.0823647

Minimum	1
Maximum	5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	884.6 KiB

Quantile statistics

Minimum	1
5-th percentile	2.4285714
Q1	3.8333333
median	4.1904762
Q3	4.6666667
95-th percentile	5
Maximum	5
Range	4
Interquartile range (IQR)	0.83333333

Descriptive statistics

Standard deviation	0.8380529
Coefficient of variation (CV)	0.20528614
Kurtosis	3.2970147
Mean	4.0823647
Median Absolute Deviation (MAD)	0.42490842
Skewness	-1.5956181
Sum	462189
Variance	0.70233267
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5	21021	18.6%
4	9087	8.0%
3	4105	3.6%
4.5	4024	3.6%
1	2815	2.5%
4.333333333	2205	1.9%
4.666666667	2139	1.9%
3.5	1848	1.6%
3.666666667	1461	1.3%
4.25	1276	1.1%
Other values (679)	63235	55.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2815	2.5%
1.142857143	7	< 0.1%
1.16	25	< 0.1%
1.2	25	< 0.1%
1.25	4	< 0.1%
1.333333333	42	< 0.1%
1.4	10	< 0.1%
1.428571429	14	< 0.1%
1.4375	16	< 0.1%
1.444444444	36	< 0.1%

Value	Count	Frequency (%)
5	21021	18.6%
4.958333333	24	< 0.1%
4.9375	16	< 0.1%
4.933333333	15	< 0.1%
4.923076923	39	< 0.1%
4.916666667	36	< 0.1%
4.909090909	88	0.1%
4.9	60	0.1%
4.896551724	29	< 0.1%
4.888888889	153	0.1%

seller_avg_review_score
Real number (ℝ)

Distinct	806
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.0823647

Minimum	1
Maximum	5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	884.6 KiB

Quantile statistics

Minimum	1
5-th percentile	3.400692
Q1	3.9285714
median	4.1126761
Q3	4.275
95-th percentile	4.592
Maximum	5
Range	4
Interquartile range (IQR)	0.34642857

Descriptive statistics

Standard deviation	0.36476856
Coefficient of variation (CV)	0.089352272
Kurtosis	8.0517235
Mean	4.0823647
Median Absolute Deviation (MAD)	0.17303823
Skewness	-1.4483469
Sum	462189
Variance	0.1330561
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.824653607	2093	1.8%
3.949903661	2076	1.8%
3.988017973	2003	1.8%
4.125273523	1828	1.6%
4.075151515	1650	1.5%
4.091823056	1492	1.3%
3.879807692	1456	1.3%
4	1449	1.3%
3.400692042	1445	1.3%
5	1246	1.1%
Other values (796)	96478	85.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	97	0.1%
1.4	20	< 0.1%
1.5	22	< 0.1%
1.666666667	18	< 0.1%
1.75	4	< 0.1%
1.8	5	< 0.1%
1.833333333	6	< 0.1%
1.928571429	14	< 0.1%
2	55	< 0.1%
2.071428571	14	< 0.1%

Value	Count	Frequency (%)
5	1246	1.1%
4.966666667	30	< 0.1%
4.956521739	23	< 0.1%
4.933333333	45	< 0.1%
4.928571429	14	< 0.1%
4.923076923	13	< 0.1%
4.916666667	12	< 0.1%
4.909090909	33	< 0.1%
4.903225806	31	< 0.1%
4.9	60	0.1%

same_city
Categorical

IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.3 MiB

0	107376
1	5840

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	113216
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	107376	94.8%
1	5840	5.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	107376	94.8%
1	5840	5.2%

Most occurring characters

Value	Count	Frequency (%)
0	107376	94.8%
1	5840	5.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	113216	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	107376	94.8%
1	5840	5.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	113216	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	107376	94.8%
1	5840	5.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	113216	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	107376	94.8%
1	5840	5.2%

Auto

Heatmap
Table

	actual_delivery_time	churn	customer_order_frequency	customer_review_average	customer_review_response_time	customer_zip_code_prefix	delivery_speed	freight_value	is_high_value_order	multiple_installments	order_item_id	order_processing_time	order_status	payment_installments	payment_sequential	payment_type	payment_value	price	product_avg_review_score	product_category_name	product_description_lenght	product_height_cm	product_length_cm	product_name_lenght	product_photos_qty	product_popularity	product_weight_g	product_weight_volume_ratio	product_width_cm	review_score	same_city	same_state	seller_avg_review_score	seller_popularity	seller_zip_code_prefix	shipping_delay
actual_delivery_time	1.000	0.024	-0.017	-0.221	-0.029	0.428	0.885	0.421	0.048	0.021	-0.022	0.091	0.000	0.040	0.009	0.011	0.123	0.113	-0.180	0.022	0.007	0.060	0.078	0.001	-0.029	0.066	0.101	0.030	0.044	0.159	0.075	0.208	-0.167	0.064	0.123	0.305
churn	0.024	1.000	-0.899	0.118	-0.007	0.014	0.042	0.054	0.167	0.030	-0.555	-0.002	0.000	-0.002	-0.307	0.275	-0.128	0.127	0.087	-0.037	0.058	-0.008	-0.026	0.015	0.078	-0.048	-0.007	0.025	-0.017	0.150	0.004	0.009	0.112	-0.016	0.005	0.051
customer_order_frequency	-0.017	-0.899	1.000	-0.141	0.014	-0.013	-0.046	-0.053	0.044	0.071	0.631	0.014	0.000	-0.012	0.364	0.172	0.152	-0.136	-0.105	0.044	-0.053	0.020	0.030	-0.019	-0.079	0.070	0.015	-0.027	0.016	0.039	0.013	0.038	-0.125	0.012	-0.010	-0.050
customer_review_average	-0.221	0.118	-0.141	1.000	0.016	-0.039	-0.180	-0.046	0.091	0.033	-0.122	-0.011	0.008	-0.028	-0.005	0.020	-0.071	0.010	0.565	-0.013	0.016	-0.010	-0.017	-0.018	0.018	-0.026	-0.016	-0.003	-0.012	0.993	0.033	0.066	0.231	-0.043	0.019	-0.151
customer_review_response_time	-0.029	-0.007	0.014	0.016	1.000	0.022	-0.024	0.015	0.000	0.003	0.021	0.005	0.000	0.006	-0.017	0.006	0.028	0.008	0.006	-0.009	0.001	0.018	0.018	0.005	-0.008	0.005	0.021	-0.003	0.019	0.004	0.000	0.005	-0.001	-0.003	0.018	-0.065
customer_zip_code_prefix	0.428	0.014	-0.013	-0.039	0.022	1.000	0.489	0.466	0.092	0.078	-0.009	0.024	0.000	0.069	-0.008	0.033	0.106	0.069	-0.026	0.016	0.031	0.020	0.009	0.016	0.027	0.021	0.027	0.019	-0.002	0.042	0.322	0.695	0.009	0.010	0.059	-0.132
delivery_speed	0.885	0.042	-0.046	-0.180	-0.024	0.489	1.000	0.455	0.050	0.055	-0.049	0.013	0.000	0.068	0.010	0.017	0.100	0.102	-0.129	-0.007	-0.002	0.026	0.046	0.019	-0.007	0.061	0.071	0.027	0.027	0.147	0.243	0.524	-0.079	0.061	0.151	0.225
freight_value	0.421	0.054	-0.053	-0.046	0.015	0.466	0.455	1.000	0.281	0.081	-0.055	0.030	0.000	0.190	0.015	0.011	0.424	0.434	-0.016	0.002	0.118	0.283	0.280	0.034	0.011	-0.033	0.447	0.171	0.272	0.012	0.049	0.138	0.010	-0.092	0.256	-0.146
is_high_value_order	0.048	0.167	0.044	0.091	0.000	0.092	0.050	0.281	1.000	0.213	0.233	0.037	0.000	0.290	-0.089	0.107	0.750	0.577	-0.033	0.026	0.114	0.207	0.155	0.005	-0.019	-0.067	0.299	0.143	0.143	0.091	0.049	0.087	0.000	-0.086	0.086	-0.048
multiple_installments	0.021	0.030	0.071	0.033	0.003	0.078	0.055	0.081	0.213	1.000	0.036	-0.274	0.003	0.927	-0.191	0.598	0.331	0.265	-0.014	-0.003	0.033	0.087	0.081	0.011	-0.005	-0.025	0.161	0.073	0.099	0.031	0.049	0.054	0.011	-0.002	0.059	-0.052
order_item_id	-0.022	-0.555	0.631	-0.122	0.021	-0.009	-0.049	-0.055	0.233	0.036	1.000	0.041	0.000	0.061	-0.006	0.021	0.257	-0.114	-0.098	0.041	-0.031	0.019	0.009	-0.021	-0.064	0.044	0.003	-0.022	-0.002	0.043	0.024	0.016	-0.110	0.006	-0.011	-0.037
order_processing_time	0.091	-0.002	0.014	-0.011	0.005	0.024	0.013	0.030	0.037	-0.274	0.041	1.000	0.000	-0.243	-0.038	0.134	0.035	-0.006	-0.013	0.008	0.019	0.009	-0.006	0.016	-0.002	0.025	0.005	0.014	-0.014	0.010	0.000	0.009	-0.024	-0.000	-0.010	0.063
order_status	0.000	0.000	0.000	0.008	0.000	0.000	0.000	0.000	0.000	0.003	0.000	0.000	1.000	-0.002	0.002	0.000	-0.000	0.001	0.004	0.002	-0.001	-0.003	0.004	0.006	0.003	-0.004	0.000	-0.000	0.001	0.010	0.000	0.000	0.001	0.000	-0.003	0.009
payment_installments	0.040	-0.002	-0.012	-0.028	0.006	0.069	0.068	0.190	0.290	0.927	0.061	-0.243	-0.002	1.000	-0.177	0.272	0.396	0.317	-0.015	-0.000	0.033	0.105	0.108	0.016	-0.004	-0.042	0.198	0.088	0.124	0.029	0.057	0.069	0.008	-0.011	0.066	-0.059
payment_sequential	0.009	-0.307	0.364	-0.005	-0.017	-0.008	0.010	0.015	-0.089	-0.191	-0.006	-0.038	0.002	-0.177	1.000	0.227	-0.213	-0.007	0.011	0.003	-0.015	0.010	0.030	-0.002	-0.003	0.041	0.027	0.001	0.026	0.008	0.003	0.007	0.001	-0.002	0.004	-0.008
payment_type	0.011	0.275	0.172	0.020	0.006	0.033	0.017	0.011	0.107	0.598	0.021	0.134	0.000	0.272	0.227	1.000	-0.092	0.032	0.018	-0.008	-0.011	0.008	0.019	-0.002	-0.003	-0.016	0.024	0.005	0.025	0.009	0.016	0.023	0.024	-0.015	0.002	-0.039
payment_value	0.123	-0.128	0.152	-0.071	0.028	0.106	0.100	0.424	0.750	0.331	0.257	0.035	-0.000	0.396	-0.213	-0.092	1.000	0.791	-0.043	0.004	0.170	0.306	0.232	0.025	-0.013	-0.036	0.454	0.172	0.234	0.028	0.003	0.020	0.001	-0.084	0.164	-0.063
price	0.113	0.127	-0.136	0.010	0.008	0.069	0.102	0.434	0.577	0.265	-0.114	-0.006	0.001	0.317	-0.007	0.032	0.791	1.000	0.024	-0.030	0.211	0.327	0.268	0.043	0.028	-0.037	0.516	0.206	0.272	0.010	0.005	0.030	0.080	-0.084	0.179	-0.029
product_avg_review_score	-0.180	0.087	-0.105	0.565	0.006	-0.026	-0.129	-0.016	-0.033	-0.014	-0.098	-0.013	0.004	-0.015	0.011	0.018	-0.043	0.024	1.000	-0.029	0.035	-0.010	-0.014	-0.038	0.037	-0.227	-0.017	0.001	-0.016	0.403	0.034	0.038	0.419	-0.175	0.044	-0.101
product_category_name	0.022	-0.037	0.044	-0.013	-0.009	0.016	-0.007	0.002	0.026	-0.003	0.041	0.008	0.002	-0.000	0.003	-0.008	0.004	-0.030	-0.029	1.000	-0.040	-0.019	-0.082	-0.024	0.101	0.009	-0.028	0.100	-0.101	0.031	0.049	0.067	-0.066	0.060	-0.054	-0.014
product_description_lenght	0.007	0.058	-0.053	0.016	0.001	0.031	-0.002	0.118	0.114	0.033	-0.031	0.019	-0.001	0.033	-0.015	-0.011	0.170	0.211	0.035	-0.040	1.000	0.134	-0.020	0.073	0.112	0.007	0.094	0.085	-0.081	0.015	0.015	0.045	0.100	-0.130	0.002	0.009
product_height_cm	0.060	-0.008	0.020	-0.010	0.018	0.020	0.026	0.283	0.207	0.087	0.019	0.009	-0.003	0.105	0.010	0.008	0.306	0.327	-0.010	-0.019	0.134	1.000	0.243	-0.056	-0.080	-0.006	0.531	-0.286	0.333	0.017	0.042	0.023	0.005	-0.079	0.049	-0.012
product_length_cm	0.078	-0.026	0.030	-0.017	0.018	0.009	0.046	0.280	0.155	0.081	0.009	-0.006	0.004	0.108	0.030	0.019	0.232	0.268	-0.014	-0.082	-0.020	0.243	1.000	0.062	0.005	-0.012	0.619	-0.102	0.630	0.017	0.061	0.035	-0.038	0.007	0.061	-0.004
product_name_lenght	0.001	0.015	-0.019	-0.018	0.005	0.016	0.019	0.034	0.005	0.011	-0.021	0.016	0.006	0.016	-0.002	-0.002	0.025	0.043	-0.038	-0.024	0.073	-0.056	0.062	1.000	0.164	0.019	0.077	0.093	0.067	0.012	0.031	0.016	-0.076	0.158	0.009	0.014
product_photos_qty	-0.029	0.078	-0.079	0.018	-0.008	0.027	-0.007	0.011	-0.019	-0.005	-0.064	-0.002	0.003	-0.004	-0.003	-0.003	-0.013	0.028	0.037	0.101	0.112	-0.080	0.005	0.164	1.000	0.001	0.004	0.092	-0.015	0.015	0.048	0.010	0.084	-0.029	-0.078	0.002
product_popularity	0.066	-0.048	0.070	-0.026	0.005	0.021	0.061	-0.033	-0.067	-0.025	0.044	0.025	-0.004	-0.042	0.041	-0.016	-0.036	-0.037	-0.227	0.009	0.007	-0.006	-0.012	0.019	0.001	1.000	-0.001	-0.022	0.025	0.014	0.044	0.033	-0.103	0.467	-0.037	0.027
product_weight_g	0.101	-0.007	0.015	-0.016	0.021	0.027	0.071	0.447	0.299	0.161	0.003	0.005	0.000	0.198	0.027	0.024	0.454	0.516	-0.017	-0.028	0.094	0.531	0.619	0.077	0.004	-0.001	1.000	0.381	0.620	0.019	0.039	0.021	-0.045	-0.027	0.094	-0.009
product_weight_volume_ratio	0.030	0.025	-0.027	-0.003	-0.003	0.019	0.027	0.171	0.143	0.073	-0.022	0.014	-0.000	0.088	0.001	0.005	0.172	0.206	0.001	0.100	0.085	-0.286	-0.102	0.093	0.092	-0.022	0.381	1.000	-0.131	0.000	0.000	0.002	-0.036	0.002	-0.000	0.004
product_width_cm	0.044	-0.017	0.016	-0.012	0.019	-0.002	0.027	0.272	0.143	0.099	-0.002	-0.014	0.001	0.124	0.026	0.025	0.234	0.272	-0.016	-0.101	-0.081	0.333	0.630	0.067	-0.015	0.025	0.620	-0.131	1.000	0.014	0.046	0.027	-0.049	0.041	0.074	-0.014
review_score	0.159	0.150	0.039	0.993	0.004	0.042	0.147	0.012	0.091	0.031	0.043	0.010	0.010	0.029	0.008	0.009	0.028	0.010	0.403	0.031	0.015	0.017	0.017	0.012	0.015	0.014	0.019	0.000	0.014	1.000	0.032	0.066	0.230	-0.043	0.018	-0.151
same_city	0.075	0.004	0.013	0.033	0.000	0.322	0.243	0.049	0.049	0.049	0.024	0.000	0.000	0.057	0.003	0.016	0.003	0.005	0.034	0.049	0.015	0.042	0.061	0.031	0.048	0.044	0.039	0.000	0.046	0.032	1.000	0.309	0.011	-0.020	-0.213	0.102
same_state	0.208	0.009	0.038	0.066	0.005	0.695	0.524	0.138	0.087	0.054	0.016	0.009	0.000	0.069	0.007	0.023	0.020	0.030	0.038	0.067	0.045	0.023	0.035	0.016	0.010	0.033	0.021	0.002	0.027	0.066	0.309	1.000	-0.027	0.046	-0.237	0.195
seller_avg_review_score	-0.167	0.112	-0.125	0.231	-0.001	0.009	-0.079	0.010	0.000	0.011	-0.110	-0.024	0.001	0.008	0.001	0.024	0.001	0.080	0.419	-0.066	0.100	0.005	-0.038	-0.076	0.084	-0.103	-0.045	-0.036	-0.049	0.230	0.011	-0.027	1.000	-0.235	0.096	-0.065
seller_popularity	0.064	-0.016	0.012	-0.043	-0.003	0.010	0.061	-0.092	-0.086	-0.002	0.006	-0.000	0.000	-0.011	-0.002	-0.015	-0.084	-0.084	-0.175	0.060	-0.130	-0.079	0.007	0.158	-0.029	0.467	-0.027	0.002	0.041	-0.043	-0.020	0.046	-0.235	1.000	-0.166	0.030
seller_zip_code_prefix	0.123	0.005	-0.010	0.019	0.018	0.059	0.151	0.256	0.086	0.059	-0.011	-0.010	-0.003	0.066	0.004	0.002	0.164	0.179	0.044	-0.054	0.002	0.049	0.061	0.009	-0.078	-0.037	0.094	-0.000	0.074	0.018	-0.213	-0.237	0.096	-0.166	1.000	-0.139
shipping_delay	0.305	0.051	-0.050	-0.151	-0.065	-0.132	0.225	-0.146	-0.048	-0.052	-0.037	0.063	0.009	-0.059	-0.008	-0.039	-0.063	-0.029	-0.101	-0.014	0.009	-0.012	-0.004	0.014	0.002	0.027	-0.009	0.004	-0.014	-0.151	0.102	0.195	-0.065	0.030	-0.139	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	order_status	order_item_id	price	freight_value	product_category_name	product_name_lenght	product_description_lenght	product_photos_qty	product_weight_g	product_length_cm	product_height_cm	product_width_cm	customer_zip_code_prefix	review_score	seller_zip_code_prefix	payment_sequential	payment_type	payment_installments	payment_value	churn	order_processing_time	shipping_delay	actual_delivery_time	delivery_speed	customer_order_frequency	customer_review_average	customer_review_response_time	product_popularity	seller_popularity	product_weight_volume_ratio	same_state	multiple_installments	product_avg_review_score	seller_avg_review_score
0	1	1	29.99	8.72	72	40.0	268.0	4.0	500.0	19.0	8.0	13.0	3149	4	9350	1	1	1	18.12	0	0.178333	-170.579722	202.477778	145.503611	3	4.0	27.730000	6	58	0.253036	1	0	4.0	4.431034
1	1	1	29.99	8.72	72	40.0	268.0	4.0	500.0	19.0	8.0	13.0	3149	4	9350	3	3	1	2.00	0	0.178333	-170.579722	202.477778	145.503611	3	4.0	27.730000	6	58	0.253036	1	0	4.0	4.431034
2	1	1	29.99	8.72	72	40.0	268.0	4.0	500.0	19.0	8.0	13.0	3149	4	9350	2	3	1	18.59	0	0.178333	-170.579722	202.477778	145.503611	3	4.0	27.730000	6	58	0.253036	1	0	4.0	4.431034
3	1	1	29.99	7.78	72	40.0	268.0	4.0	500.0	19.0	8.0	13.0	3366	4	9350	1	1	3	37.77	1	1.595833	-225.254722	68.253333	23.269444	1	4.0	39.276667	6	58	0.253036	1	1	4.0	4.431034
4	1	1	29.99	7.78	72	40.0	268.0	4.0	500.0	19.0	8.0	13.0	2290	5	9350	1	1	1	37.77	1	0.307778	-173.499722	120.087222	72.905000	1	5.0	23.439722	6	58	0.253036	1	0	4.0	4.431034
5	1	1	29.99	14.10	72	40.0	268.0	4.0	500.0	19.0	8.0	13.0	88032	3	9350	1	0	1	44.09	1	26.790278	-125.916944	354.636944	265.270278	1	3.0	67.877222	6	58	0.253036	0	0	4.0	4.431034
6	1	1	75.90	7.79	9	58.0	398.0	3.0	238.0	20.0	10.0	15.0	8577	5	9350	1	1	1	83.69	1	0.237222	-148.940000	149.461389	125.183611	1	5.0	108.724167	9	58	0.079333	1	0	4.0	4.431034
7	1	1	75.90	7.79	9	58.0	398.0	3.0	238.0	20.0	10.0	15.0	13060	4	9350	1	1	2	83.69	1	0.203333	-50.009444	259.940278	222.115833	1	4.0	68.177222	9	58	0.079333	1	1	4.0	4.431034
8	1	1	75.90	14.28	9	58.0	398.0	3.0	238.0	20.0	10.0	15.0	82030	5	9350	1	0	1	90.18	1	10.313889	-316.052778	195.420833	149.337778	1	5.0	45.143889	9	58	0.079333	0	0	4.0	4.431034
9	1	1	75.90	7.79	9	58.0	398.0	3.0	238.0	20.0	10.0	15.0	13092	2	9350	1	1	2	83.69	1	0.311111	-252.053056	45.864167	22.070556	1	2.0	36.416111	9	58	0.079333	1	1	4.0	4.431034

	order_status	order_item_id	price	freight_value	product_category_name	product_name_lenght	product_description_lenght	product_photos_qty	product_weight_g	product_length_cm	product_height_cm	product_width_cm	customer_zip_code_prefix	review_score	seller_zip_code_prefix	payment_sequential	payment_type	payment_installments	payment_value	churn	order_processing_time	shipping_delay	actual_delivery_time	delivery_speed	customer_order_frequency	customer_review_average	customer_review_response_time	product_popularity	seller_popularity	product_weight_volume_ratio	same_state	is_high_value_order	multiple_installments	product_avg_review_score	seller_avg_review_score
113206	1	1	89.90	18.73	54	50.0	1141.0	2.0	450.0	16.0	16.0	16.0	38181	4	17512	1	1	1	108.63	1	0.192778	-316.288333	123.398889	101.195000	1	4.0	196.772500	1	1	0.109863	0	0	0	4.0	4.0
113207	1	1	29.40	17.92	8	48.0	62.0	1.0	700.0	16.0	7.0	11.0	45051	5	2116	1	1	4	47.32	1	0.227222	-292.297222	416.207500	405.125556	1	5.0	134.581944	1	1	0.568182	0	0	1	5.0	5.0
113208	1	1	45.00	10.96	49	45.0	1403.0	1.0	300.0	28.0	2.0	18.0	9060	5	6080	1	1	1	8.25	0	0.000000	-325.418333	118.885556	102.264167	2	5.0	48.996944	2	2	0.297619	1	0	0	5.0	5.0
113209	1	1	45.00	10.96	49	45.0	1403.0	1.0	300.0	28.0	2.0	18.0	9060	5	6080	2	3	1	47.71	0	0.000000	-325.418333	118.885556	102.264167	2	5.0	48.996944	2	2	0.297619	1	0	0	5.0	5.0
113210	1	1	44.99	22.25	32	60.0	645.0	2.0	600.0	30.0	20.0	20.0	39810	5	88490	1	1	2	134.48	0	0.179722	-211.724722	247.032222	182.375278	2	5.0	22.031944	2	2	0.050000	0	0	1	5.0	5.0
113211	1	2	44.99	22.25	32	60.0	645.0	2.0	600.0	30.0	20.0	20.0	39810	5	88490	1	1	2	134.48	0	0.179722	-211.724722	247.032222	182.375278	2	5.0	22.031944	2	2	0.050000	0	0	1	5.0	5.0
113212	1	1	79.00	14.13	23	40.0	516.0	2.0	750.0	30.0	28.0	28.0	8528	5	13660	1	0	1	93.13	1	101.911667	-248.884167	196.729722	120.549167	1	5.0	18.541389	1	1	0.031888	1	0	0	5.0	5.0
113213	1	1	399.00	45.07	54	43.0	729.0	2.0	2100.0	80.0	8.0	30.0	60455	5	13478	1	2	1	444.07	1	1.633333	-313.206944	229.018889	223.559722	1	5.0	35.377778	1	1	0.109375	0	1	0	5.0	5.0
113214	1	1	219.90	24.12	54	19.0	531.0	1.0	5900.0	41.0	21.0	41.0	39803	4	8320	1	1	4	244.02	1	0.371944	119.191389	505.968889	466.724722	1	4.0	81.296389	1	1	0.167134	0	1	1	4.0	4.0
113215	1	1	15.50	12.79	62	40.0	871.0	1.0	83.0	17.0	8.0	13.0	9687	5	14092	1	0	1	28.29	1	9.908056	-177.471944	140.844722	117.194722	1	5.0	15.239722	1	1	0.046946	1	0	0	5.0	5.0

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII